/**
 * Copyright 2005 The Apache Software Foundation
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.edi.db.type;

import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.sql.Types;
import java.text.SimpleDateFormat;
import java.util.Calendar;

import com.edi.db.EdiDb;

public class DateType extends NullableType {
	private static final String DATE_FORMAT = "yyyy-MM-dd HH:mm:ss";

	public Class getReturnedClass() {
		return java.util.Date.class;
	}

	public Object get(ResultSet rs, String name) throws SQLException {
		return rs.getDate(name);
	}

	public void set(PreparedStatement st, Object value, int index)
			throws SQLException {

		Timestamp sqlDate = null;
		if (value != null) {
			if (value instanceof Date) {
				sqlDate = new Timestamp(((Date) value).getTime());
			} else {
				sqlDate = new Timestamp(((java.util.Date) value).getTime());
			}
		}

		st.setTimestamp(index, sqlDate);
	}

	public int sqlType() {
		return Types.DATE;
	}

	public boolean isEqual(Object x, Object y) {

		if (x == y)
			return true;
		if (x == null || y == null)
			return false;

		java.util.Date xdate = (java.util.Date) x;
		java.util.Date ydate = (java.util.Date) y;

		if (xdate.getTime() == ydate.getTime())
			return true;

		Calendar calendar1 = java.util.Calendar.getInstance();
		Calendar calendar2 = java.util.Calendar.getInstance();
		calendar1.setTime(xdate);
		calendar2.setTime(ydate);

		return EdiDb.CALENDAR_DATE.isEqual(calendar1, calendar2);

	}

	public String getName() {
		return "date";
	}

	@Override
	public String getTypeValue(Object value) {
		// TODO Auto-generated method stub
		return new SimpleDateFormat(DATE_FORMAT)
				.format(((java.util.Date) value));
	}
}
